SQL Statements for the creation of Users/tables in ORACLE:

Use Default ‘SYSTEM’ Username and ‘manager’ Password to create User in Oracle as: 

********************************************************************************
CREATE USER "CCSMS” PROFILE "DEFAULT" 
    IDENTIFIED BY "zzz" DEFAULT TABLESPACE "USERS" 
    ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "CCSMS";
GRANT "CONNECT" TO "CCSMS";
GRANT "RESOURCE" TO "CCSMS";
********************************************************************************
Now, Log in to ‘CCSMS’ Oracle User Profile as created above, and these SQLs:

********************************************************************************

CREATE TABLE LOGIN_INFO
(
USERNAME VARCHAR2 (25),
PASSWORD VARCHAR2 (25),
USERPROFILE VARCHAR2 (25)
);

INSERT INTO LOGIN_INFO
(USERNAME, PASSWORD, USERPROFILE)
VALUES ('ADMIN', '123', 'ADMINISTRATOR');

/
 INSERT INTO LOGIN_INFO
 (USERNAME, PASSWORD, USERPROFILE)
 VALUES ('SURAJ', 'ZZZ', 'RECEPTION');
 /

CREATE TABLE EMPLOYEE_INFO 
(
EMPLOYEE_ID VARCHAR2 (15),
EMPLOYEE_NAME VARCHAR2 (35),
DESIGNATION VARCHAR2 (35),
SPECIALIZATION VARCHAR2 (35),
SEX VARCHAR2 (1),
DATE_OF_BIRTH DATE,
S_PHOTO LONG RAW,
QUALIFICATION VARCHAR2 (51),
NATIONALITY VARCHAR2 (25),
PERMANENT_ADDRESS VARCHAR2 (151),
CORRESPONDENCE_ADDRESS VARCHAR2 (151),
PHONE_NO_R VARCHAR2 (15),
PHONE_NO_O VARCHAR2 (15),
MOBILE VARCHAR2 (15),
EMAIL VARCHAR2 (35),
FAX_NO VARCHAR2 (15),
DATE_OF_JOINING DATE,
DUTY_SLOT_TIME VARCHAR2 (25),
BASIC_SALARY_DAY_SHIFT NUMBER (10, 2),
BASIC_SALARY_NIGHT_SHIFT NUMBER (10, 2),
OT_SALARY_PER_HR_DAY_SHIFT NUMBER (10, 2),
OT_SALARY_PER_HR_NIGHT_SHIFT NUMBER (10, 2),
DESCRIPTION VARCHAR2 (151),
PRIMARY KEY (EMPLOYEE_ID)
);

CREATE TABLE REGULAR_ATTENDENCE (
EMPLOYEE_ID VARCHAR2 (15),
REGULAR_TIMING VARCHAR2 (25),
SHIFT VARCHAR2 (15),
ATTENDANCE_STATUS VARCHAR2 (1),	
ATTENDANCE_DATE DATE,
ATTENDANCE_MONTH VARCHAR2 (50),
FOREIGN KEY (EMPLOYEE_ID) 
REFERENCES EMPLOYEE_INFO (EMPLOYEE_ID)
);

CREATE TABLE OVERTIME_ATTENDENCE (
EMPLOYEE_ID VARCHAR2 (15),
ATTENDANCE_TIMING VARCHAR2 (25),
SHIFT VARCHAR2 (15),
OVERTIME_HOURS VARCHAR2 (2),
ATTENDANCE_DATE DATE,
ATTENDANCE_MONTH VARCHAR2 (50),
FOREIGN KEY (EMPLOYEE_ID) 
REFERENCES EMPLOYEE_INFO (EMPLOYEE_ID)
);

CREATE TABLE EMPLOYEE_PAYROLL (
EMPLOYEE_ID VARCHAR2 (15),
NOD_REGULAR_DAY NUMBER,
NOD_REGULAR_NIGHT NUMBER,
NOHR_OVERTIME_DAY NUMBER,
NOHR_OVERTIME_NIGHT NUMBER,
PAYMENT_REGULAR_DAY NUMBER,
PAYMENT_REGULAR_NIGHT NUMBER,
PAYMENT_OVERTIME_DAY NUMBER,
PAYMENT_OVERTIME_NIGHT NUMBER,
OTHER_ALLOWENCE NUMBER,
PAYMENT_AMOUNT NUMBER,
NET_PAYMENT NUMBER,
PAID_AMOUNT NUMBER,
BALANCE_AMOUNT NUMBER,
PAYMENT_DATE DATE,
FOREIGN KEY (EMPLOYEE_ID) 
REFERENCES EMPLOYEE_INFO (EMPLOYEE_ID)
)
;
CREATE TABLE EMPLOYEE_ADVANCE_PAYMENT (
EMPLOYEE_ID VARCHAR2 (15),
ADVANCE_PAYMENT_AMOUNT NUMBER,
PAYMENT_DATE DATE,
FOREIGN KEY (EMPLOYEE_ID) 
REFERENCES EMPLOYEE_INFO (EMPLOYEE_ID)
)
;

CREATE TABLE EMPLOYEE_WORKING_DAYS
(
EMPLOYEE_ID VARCHAR2 (15),
NO_OF_WORKING_DAYS NUMBER,
SUN NUMBER,
MON NUMBER,
TUE NUMBER,
WED NUMBER,
THU NUMBER,
FRI NUMBER,
SAT NUMBER,
PRIMARY KEY (EMPLOYEE_ID),
FOREIGN KEY (EMPLOYEE_ID)
REFERENCES EMPLOYEE_INFO (EMPLOYEE_ID)
);

CREATE TABLE CUSTOMER_INFO
(
CUSTOMER_ID VARCHAR2 (15),
CUSTOMER_TYPE VARCHAR2 (21),
CUSTOMER_NAME VARCHAR2 (35),
ADDRESS VARCHAR2 (151),
PHONE_NO VARCHAR2 (15),
MOBILE VARCHAR2 (15),
EMAIL VARCHAR2 (35),
FAX_NO VARCHAR2 (15),
DATE_OF_JOINING DATE,
DESCRIPTION VARCHAR2 (151),
PRIMARY KEY (CUSTOMER_ID)
)
;

CREATE TABLE SERVICE
(
SERVICE_SERIAL_NO NUMBER,
SYSTEM_DATE DATE,
SYSTEM_TIME VARCHAR2 (15),
CUSTOMER_ID VARCHAR2 (15),
CUSTOMER_TYPE VARCHAR2 (21),
C_NAME VARCHAR2 (35),
C_ADDRESS VARCHAR2 (151),
C_PHONE VARCHAR2 (15),
C_MOBILE VARCHAR2 (15),
C_FAX VARCHAR2 (15),
C_E_MAIL_ID VARCHAR2 (35),
C_DESCRIPTION VARCHAR2 (101),
SERVICE_TYPE VARCHAR2 (51),
SERVICE_REQUESTED VARCHAR2 (551),
PRIORITY VARCHAR2 (15),
JOB_STATUS VARCHAR2 (21), 
RESPONCE_DETAIL VARCHAR2 (551),
DATE_ALLOTTED DATE,
TIME_ALLOTTED VARCHAR2 (21),
PRIMARY KEY (SERVICE_SERIAL_NO),
FOREIGN KEY (CUSTOMER_ID)
REFERENCES CUSTOMER_INFO (CUSTOMER_ID)
)
;

CREATE TABLE WARRENTY_PRODUCTS
(
CUSTOMER_ID VARCHAR2 (15),
PRODUCT_SERIAL_NO VARCHAR2 (21),
PRODUCT_OR_SERVICE VARCHAR2 (35),
WARRENTY_START_DATE DATE,
WARRENTY_END_DATE DATE,
PRICE NUMBER (12, 2),
FOREIGN KEY (CUSTOMER_ID)
REFERENCES CUSTOMER_INFO (CUSTOMER_ID)
)
;

CREATE TABLE SERVICE_VARCHAR2GES
(
SERVICE_SERIAL_NO NUMBER,
CUSTOMER_ID VARCHAR2 (15),
CUSTOMER_TYPE VARCHAR2 (21),
PRODUCT_SERIAL_NO VARCHAR2 (21),
PRODUCT_OR_SERVICE VARCHAR2 (35),
CHARGED_AMOUNT NUMBER (12, 2),
PAYED_AMOUNT NUMBER (12, 2),
DUE_AMOUNT NUMBER (12, 2),
PAY_IT_OR_NOT VARCHAR2 (3),
FOREIGN KEY (SERVICE_SERIAL_NO)
REFERENCES SERVICE (SERVICE_SERIAL_NO),
FOREIGN KEY (CUSTOMER_ID)
REFERENCES CUSTOMER_INFO (CUSTOMER_ID)
);

CREATE TABLE PRODUCTS_STOCK
(
PRODUCT_ID VARCHAR2 (15),
PRODUCT VARCHAR2 (51),
MANUFACTURER VARCHAR2 (51),
MODEL_NO VARCHAR2 (25),
DESCRIPTION VARCHAR2 (31),
QUANTINTY NUMBER,
MRP NUMBER (12, 2),
PRIMARY KEY (PRODUCT_ID)
);